Pruning Attributes From Data Cubes with Diamond Dicing

Data stored in a data warehouse are inherently multidimensional, but most data-pruning techniques (such as iceberg and top-k queries) are unidimensional. However, analysts need to issue multidimensional queries. For example, an analyst may need to select not just the most profitable stores or--separately--the most profitable products, but simultaneous sets of stores and products fulfilling some profitability constraints. To fill this need, we propose a new operator, the diamond dice. Because of the interaction between dimensions, the computation of diamonds is challenging. We present the first diamond-dicing experiments on large data sets. Experiments show that we can compute diamond cubes over fact tables containing 100 million facts in less than 35 minutes using a standard PC

Diamond Dicing

In OLAP, analysts often select an interesting sample of the data. For example, an analyst might focus on products bringing revenues of at least 100 000 dollars, or on shops having sales greater than 400 000 dollars. However, current systems do not allow the application of both of these thresholds simultaneously, selecting products and shops satisfying both thresholds. For such purposes, we introduce the diamond cube operator, filling a gap among existing data warehouse operations. Because of the interaction between dimensions the computation of diamond cubes is challenging. We compare and test various algorithms on large data sets of more than 100 million facts. We find that while it is possible to implement diamonds in SQL, it is inefficient. Indeed, our custom implementation can be a hundred times faster than popular database engines (including a row-store and a column-store).Comment: 29 page

The Use of Interferon Gamma Inducible Protein 10 as a Potential Biomarker in the Diagnosis of Latent Tuberculosis Infection in Uganda.

BACKGROUND: In the absence of a gold standard for the diagnosis of latent tuberculosis (TB) infection (LTBI), the current tests available for the diagnosis of LTBI are limited by their inability to differentiate between LTBI and active TB disease. We investigated IP-10 as a potential biomarker for LTBI among household contacts exposed to sputum positive active TB cases. METHODS: Active TB cases and contacts were recruited into a cohort with six months' follow-up. Contacts were tested for LTBI using QuantiFERON®-TB Gold In-Tube (QFN) assay and the tuberculin skin test (TST). Baseline supernatants from the QFN assay of 237 contacts and 102 active TB cases were analysed for Mycobacterium tuberculosis (MTB) specific and mitogen specific IP-10 responses. RESULTS: Contacts with LTBI (QFN+TST+) had the highest MTB specific IP-10 responses at baseline, compared to uninfected contacts (QFN-TST-) p<0.0001; and active cases, p = 0.01. Using a cut-off of 8,239 pg/ml, MTB specific IP-10 was able to diagnose LTBI with a sensitivity of 87.1% (95% CI, 76.2-94.3) and specificity of 90.9% (95% CI, 81.3-96.6). MTB specific to mitogen specific IP-10 ratio was higher in HIV negative active TB cases, compared to HIV negative latently infected contacts, p = 0.0004. Concentrations of MTB specific IP-10 were higher in contacts with TST conversion (negative at baseline, positive at 6-months) than in those that were persistently TST negative, p = 0.001. CONCLUSION: IP-10 performed well in differentiating contacts with either latent or active TB from those who were uninfected but was not able to differentiate LTBI from active disease except when MTB specific to mitogen specific ratios were used in HIV negative adults. In addition, IP-10 had the potential to diagnose 'recent TB infection' in persons classified as having LTBI using the TST. Such individuals with strong IP-10 responses would likely benefit from chemoprophylaxis

Genetic aspects of congenital nephrotic syndrome : a consensus statement from the ERKNet-ESPN inherited glomerulopathy working group

Congenital nephrotic syndrome (CNS) is a heterogeneous group of disorders presenting with massive proteinuria within the first 3 months of life almost inevitably leading to end-stage kidney disease. The Work Group for the European Reference Network for Kidney Diseases (ERKNet) and the European Society for Pediatric Nephrology (ESPN) has developed consensus statement on genetic aspects of CNS diagnosis and management. The presented expert opinion recommends genetic diagnostics as the key diagnostic test to be ordered already during the initial evaluation of the patient, discusses which phenotyping workup should be performed and presents known genotype-phenotype correlations.Peer reviewe

Influence of a dam on fine-sediment storage in a canyon river

Glen Canyon Dam has caused a fundamental change in the distribution of fine sediment storage in the 99-km reach of the Colorado River in Marble Canyon, Grand Canyon National Park, Arizona. The two major storage sites for fine sediment (i.e., sand and finer material) in this canyon river are lateral recirculation eddies and the main-channel bed. We use a combination of methods, including direct measurement of sediment storage change, measurements of sediment flux, and comparison of the grain size of sediment found in different storage sites relative to the supply and that in transport, in order to evaluate the change in both the volume and location of sediment storage. The analysis shows that the bed of the main channel was an important storage environment for fine sediment in the predam era. In years of large seasonal accumulation, approximately 50% of the fine sediment supplied to the reach from upstream sources was stored on the main-channel bed. In contrast, sediment budgets constructed for two short-duration, high experimental releases from Glen Canyon Dam indicate that approximately 90% of the sediment discharge from the reach during each release was derived from eddy storage, rather than from sandy deposits on the main-channel bed. These results indicate that the majority of the fine sediment in Marble Canyon is now stored in eddies, even though they occupy a small percentage ( similar to 17%) of the total river area. Because of a 95% reduction in the supply of fine sediment to Marble Canyon, future high releases without significant input of tributary sediment will potentially erode sediment from long-term eddy storage, resulting in continued degradation in Marble Canyon

Management of congenital nephrotic syndrome : consensus recommendations of the ERKNet-ESPN Working Group

Publisher Copyright: © 2021, The Author(s).Congenital nephrotic syndrome (CNS) is a heterogeneous group of disorders characterized by nephrotic-range proteinuria, hypoalbuminaemia and oedema, which manifest in utero or during the first 3 months of life. The main cause of CNS is genetic defects in podocytes; however, it can also be caused, in rare cases, by congenital infections or maternal allo-immune disease. Management of CNS is very challenging because patients are prone to severe complications, such as haemodynamic compromise, infections, thromboses, impaired growth and kidney failure. In this consensus statement, experts from the European Reference Network for Kidney Diseases (ERKNet) and the European Society for Paediatric Nephrology (ESPN) summarize the current evidence and present recommendations for the management of CNS, including the use of renin–angiotensin system inhibitors, diuretics, anticoagulation and infection prophylaxis. Therapeutic management should be adapted to the clinical severity of the condition with the aim of maintaining intravascular euvolaemia and adequate nutrition, while preventing complications and preserving central and peripheral vessels. We do not recommend performing routine early nephrectomies but suggest that they are considered in patients with severe complications despite optimal conservative treatment, and before transplantation in patients with persisting nephrotic syndrome and/or a WT1-dominant pathogenic variant.Peer reviewe

Maternal BCG scar is associated with increased infant proinflammatory immune responses.

INTRODUCTION: Prenatal exposures such as infections and immunisation may influence infant responses. We had an opportunity to undertake an analysis of innate responses in infants within the context of a study investigating the effects of maternal mycobacterial exposures and infection on BCG vaccine-induced responses in Ugandan infants. MATERIAL AND METHODS: Maternal and cord blood samples from 29 mother-infant pairs were stimulated with innate stimuli for 24h and cytokines and chemokines in supernatants were measured using the Luminex® assay. The associations between maternal latent Mycobacterium tuberculosis infection (LTBI), maternal BCG scar (adjusted for each other's effect) and infant responses were examined using linear regression. Principal Component Analysis (PCA) was used to assess patterns of cytokine and chemokine responses. Gene expression profiles for pathways associated with maternal LTBI and with maternal BCG scar were examined using samples collected at one (n=42) and six (n=51) weeks after BCG immunisation using microarray. RESULTS: Maternal LTBI was positively associated with infant IP-10 responses with an adjusted geometric mean ratio (aGMR) [95% confidence interval (CI)] of 5.10 [1.21, 21.48]. Maternal BCG scar showed strong and consistent associations with IFN-? (aGMR 2.69 [1.15, 6.17]), IL-12p70 (1.95 [1.10, 3.55]), IL-10 (1.82 [1.07, 3.09]), VEGF (3.55 [1.07, 11.48]) and IP-10 (6.76 [1.17, 38.02]). Further assessment of the associations using PCA showed no differences for maternal LTBI, but maternal BCG scar was associated with higher scores for principal component (PC) 1 (median level of scores: 1.44 in scar-positive versus -0.94 in scar-negative, p=0.020) in the infants. PC1 represented a controlled proinflammatory response. Interferon and inflammation response pathways were up-regulated in infants of mothers with LTBI at six weeks, and in infants of mothers with a BCG scar at one and six weeks after BCG immunisation. CONCLUSIONS: Maternal BCG scar had a stronger association with infant responses than maternal LTBI, with an increased proinflammatory immune profile

The impact of maternal infection with Mycobacterium tuberculosis on the infant response to bacille Calmette-Guérin immunization.

Bacille Calmette-Guérin (BCG) immunization provides variable protection against tuberculosis. Prenatal antigen exposure may have lifelong effects on responses to related antigens and pathogens. We therefore hypothesized that maternal latent Mycobacterium tuberculosis infection (LTBI) influences infant responses to BCG immunization at birth. We measured antibody (n = 53) and cellular (n = 31) responses to M. tuberculosis purified protein derivative (PPD) in infants of mothers with and without LTBI, in cord blood and at one and six weeks after BCG. The concentrations of PPD-specific antibodies declined between birth (median [interquartile range (IQR)]) 5600 ng ml(-1) [3300-11 050] in cord blood) and six weeks (0.00 ng ml(-1) [0-288]). Frequencies of PPD-specific IFN-γ-expressing CD4(+)T cells increased at one week and declined between one and six weeks (p = 0.031). Frequencies of IL-2- and TNF-α-expressing PPD-specific CD4(+)T cells increased between one and six weeks (p = 0.019, p = 0.009, respectively). At one week, the frequency of PPD-specific CD4(+)T cells expressing any of the three cytokines, combined, was lower among infants of mothers with LTBI, in crude analyses (p = 0.002) and after adjusting for confounders (mean difference, 95% CI -0.041% (-0.082, -0.001)). In conclusion, maternal LTBI was associated with lower infant anti-mycobacterial T-cell responses immediately following BCG immunization. These findings are being explored further in a larger study

Correction to: Investigating the non-specific effects of BCG vaccination on the innate immune system in Ugandan neonates: study protocol for a randomised controlled trial.

An amendment to this paper has been published and can be accessed via the original article